Overview
Brought to you by YData
Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 346018 |
| Missing cells | 1565549 |
| Missing cells (%) | 14.6% |
| Duplicate rows | 1302 |
| Duplicate rows (%) | 0.4% |
| Total size in memory | 81.8 MiB |
| Average record size in memory | 248.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Text | 18 |
| Categorical | 5 |
| Numeric | 6 |
| Boolean | 1 |
| Dataset has 1302 (0.4%) duplicate rows | Duplicates |
Sub-Acquisition Method is highly imbalanced (51.4%) | Imbalance |
CalCard is highly imbalanced (88.4%) | Imbalance |
Purchase Date has 17436 (5.0%) missing values | Missing |
LPA Number has 253673 (73.3%) missing values | Missing |
Requisition Number has 331649 (95.8%) missing values | Missing |
Sub-Acquisition Type has 277681 (80.3%) missing values | Missing |
Sub-Acquisition Method has 315122 (91.1%) missing values | Missing |
Supplier Qualifications has 204273 (59.0%) missing values | Missing |
Supplier Zip Code has 70110 (20.3%) missing values | Missing |
Location has 70110 (20.3%) missing values | Missing |
Supplier Code is highly skewed (γ1 = 343.4821729) | Skewed |
Quantity is highly skewed (γ1 = 117.4482872) | Skewed |
Supplier Code has 4473 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2024-12-15 13:19:07.417860 |
|---|---|
| Analysis finished | 2024-12-15 13:19:54.971040 |
| Duration | 47.55 seconds |
| Software version | ydata-profiling vv4.12.1 |
| Download configuration | config.json |
Variables
Creation Date
Date
| Distinct | 1015 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2012-07-02 00:00:00 |
|---|---|
| Maximum | 2015-06-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Purchase Date
Text
Missing 
| Distinct | 2268 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 17436 |
| Missing (%) | 5.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 328 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 06/05/2014 |
|---|---|
| 2nd row | 03/12/2014 |
| 3rd row | 10/01/2014 |
| 4th row | 04/14/2014 |
| 5th row | 07/26/2013 |
| Value | Count | Frequency (%) |
| 07/01/2014 | 4499 | 1.4% |
| 07/01/2013 | 4462 | 1.4% |
| 07/01/2015 | 2755 | 0.8% |
| 07/01/2012 | 2218 | 0.7% |
| 05/01/2013 | 1221 | 0.4% |
| 05/27/2014 | 1126 | 0.3% |
| 06/05/2013 | 1117 | 0.3% |
| 09/25/2013 | 1072 | 0.3% |
| 03/25/2014 | 1018 | 0.3% |
| 06/30/2015 | 1006 | 0.3% |
| Other values (2258) | 308088 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 754765 | |
| / | 657164 | |
| 1 | 597757 | |
| 2 | 559696 | |
| 3 | 180341 | 5.5% |
| 4 | 164978 | 5.0% |
| 5 | 120727 | 3.7% |
| 6 | 68665 | 2.1% |
| 7 | 64861 | 2.0% |
| 9 | 59012 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3285820 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 754765 | |
| / | 657164 | |
| 1 | 597757 | |
| 2 | 559696 | |
| 3 | 180341 | 5.5% |
| 4 | 164978 | 5.0% |
| 5 | 120727 | 3.7% |
| 6 | 68665 | 2.1% |
| 7 | 64861 | 2.0% |
| 9 | 59012 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3285820 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 754765 | |
| / | 657164 | |
| 1 | 597757 | |
| 2 | 559696 | |
| 3 | 180341 | 5.5% |
| 4 | 164978 | 5.0% |
| 5 | 120727 | 3.7% |
| 6 | 68665 | 2.1% |
| 7 | 64861 | 2.0% |
| 9 | 59012 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3285820 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 754765 | |
| / | 657164 | |
| 1 | 597757 | |
| 2 | 559696 | |
| 3 | 180341 | 5.5% |
| 4 | 164978 | 5.0% |
| 5 | 120727 | 3.7% |
| 6 | 68665 | 2.1% |
| 7 | 64861 | 2.0% |
| 9 | 59012 | 1.8% |
Fiscal Year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 2013-2014 | |
|---|---|
| 2014-2015 | |
| 2012-2013 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2013-2014 |
|---|---|
| 2nd row | 2013-2014 |
| 3rd row | 2013-2014 |
| 4th row | 2013-2014 |
| 5th row | 2013-2014 |
Common Values
| Value | Count | Frequency (%) |
| 2013-2014 | 120636 | |
| 2014-2015 | 116537 | |
| 2012-2013 | 108845 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2013-2014 | 120636 | |
| 2014-2015 | 116537 | |
| 2012-2013 | 108845 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 800881 | |
| 0 | 692036 | |
| 1 | 692036 | |
| - | 346018 | |
| 4 | 237173 | 7.6% |
| 3 | 229481 | 7.4% |
| 5 | 116537 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3114162 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 800881 | |
| 0 | 692036 | |
| 1 | 692036 | |
| - | 346018 | |
| 4 | 237173 | 7.6% |
| 3 | 229481 | 7.4% |
| 5 | 116537 | 3.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3114162 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 800881 | |
| 0 | 692036 | |
| 1 | 692036 | |
| - | 346018 | |
| 4 | 237173 | 7.6% |
| 3 | 229481 | 7.4% |
| 5 | 116537 | 3.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3114162 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 800881 | |
| 0 | 692036 | |
| 1 | 692036 | |
| - | 346018 | |
| 4 | 237173 | 7.6% |
| 3 | 229481 | 7.4% |
| 5 | 116537 | 3.7% |
LPA Number
Text
Missing 
| Distinct | 1420 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 253673 |
| Missing (%) | 73.3% |
| Memory size | 2.6 MiB |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 11.036104 |
| Min length | 2 |
Unique
| Unique | 399 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 7-12-70-26 |
|---|---|
| 2nd row | 1-10-75-60A |
| 3rd row | 1-14-75-60A |
| 4th row | 1-14-75-60A |
| 5th row | SBP01337 |
| Value | Count | Frequency (%) |
| 7-11-51-02 | 9267 | 8.9% |
| 4105 | 3.9% | |
| 1-10-75-60a | 3763 | 3.6% |
| 1-12-65-65-01-e | 3717 | 3.6% |
| a | 3243 | 3.1% |
| g | 3229 | 3.1% |
| 1-11-70-04o | 3097 | 3.0% |
| 1-13-70-02a | 2612 | 2.5% |
| 1-11-70-04q | 2481 | 2.4% |
| 1-13-70-01a | 2098 | 2.0% |
| Other values (1415) | 67064 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 281197 | |
| 1 | 210038 | |
| 0 | 125737 | |
| 7 | 62873 | 6.2% |
| 5 | 52827 | 5.2% |
| 2 | 50578 | 5.0% |
| 3 | 40364 | 4.0% |
| 9 | 31213 | 3.1% |
| 4 | 30075 | 3.0% |
| 6 | 29901 | 2.9% |
| Other values (34) | 104326 | 10.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1019129 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 281197 | |
| 1 | 210038 | |
| 0 | 125737 | |
| 7 | 62873 | 6.2% |
| 5 | 52827 | 5.2% |
| 2 | 50578 | 5.0% |
| 3 | 40364 | 4.0% |
| 9 | 31213 | 3.1% |
| 4 | 30075 | 3.0% |
| 6 | 29901 | 2.9% |
| Other values (34) | 104326 | 10.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1019129 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 281197 | |
| 1 | 210038 | |
| 0 | 125737 | |
| 7 | 62873 | 6.2% |
| 5 | 52827 | 5.2% |
| 2 | 50578 | 5.0% |
| 3 | 40364 | 4.0% |
| 9 | 31213 | 3.1% |
| 4 | 30075 | 3.0% |
| 6 | 29901 | 2.9% |
| Other values (34) | 104326 | 10.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1019129 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 281197 | |
| 1 | 210038 | |
| 0 | 125737 | |
| 7 | 62873 | 6.2% |
| 5 | 52827 | 5.2% |
| 2 | 50578 | 5.0% |
| 3 | 40364 | 4.0% |
| 9 | 31213 | 3.1% |
| 4 | 30075 | 3.0% |
| 6 | 29901 | 2.9% |
| Other values (34) | 104326 | 10.2% |
| Distinct | 200533 |
|---|---|
| Distinct (%) | 58.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 31 |
| Mean length | 8.969938 |
| Min length | 1 |
Unique
| Unique | 166350 ? |
|---|---|
| Unique (%) | 48.1% |
Sample
| 1st row | REQ0011118 |
|---|---|
| 2nd row | REQ0011932 |
| 3rd row | REQ0011476 |
| 4th row | 4500236642 |
| 5th row | 4500221028 |
| Value | Count | Frequency (%) |
| 2660 | 1393 | 0.4% |
| prf | 930 | 0.3% |
| boe | 631 | 0.2% |
| 4500211314 | 602 | 0.2% |
| 4500201426 | 579 | 0.2% |
| 4500204899 | 578 | 0.2% |
| 4500203794 | 578 | 0.2% |
| 4500202454 | 564 | 0.2% |
| 4500198630 | 547 | 0.2% |
| 4500210216 | 546 | 0.2% |
| Other values (199482) | 346489 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 664769 | |
| 1 | 386930 | |
| 4 | 322860 | |
| 2 | 295105 | |
| 5 | 282763 | |
| 3 | 215362 | 6.9% |
| 6 | 152176 | 4.9% |
| 7 | 133355 | 4.3% |
| 8 | 131526 | 4.2% |
| 9 | 124993 | 4.0% |
| Other values (72) | 393921 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3103760 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 664769 | |
| 1 | 386930 | |
| 4 | 322860 | |
| 2 | 295105 | |
| 5 | 282763 | |
| 3 | 215362 | 6.9% |
| 6 | 152176 | 4.9% |
| 7 | 133355 | 4.3% |
| 8 | 131526 | 4.2% |
| 9 | 124993 | 4.0% |
| Other values (72) | 393921 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3103760 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 664769 | |
| 1 | 386930 | |
| 4 | 322860 | |
| 2 | 295105 | |
| 5 | 282763 | |
| 3 | 215362 | 6.9% |
| 6 | 152176 | 4.9% |
| 7 | 133355 | 4.3% |
| 8 | 131526 | 4.2% |
| 9 | 124993 | 4.0% |
| Other values (72) | 393921 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3103760 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 664769 | |
| 1 | 386930 | |
| 4 | 322860 | |
| 2 | 295105 | |
| 5 | 282763 | |
| 3 | 215362 | 6.9% |
| 6 | 152176 | 4.9% |
| 7 | 133355 | 4.3% |
| 8 | 131526 | 4.2% |
| 9 | 124993 | 4.0% |
| Other values (72) | 393921 |
Missing 
| Distinct | 5997 |
|---|---|
| Distinct (%) | 41.7% |
| Missing | 331649 |
| Missing (%) | 95.8% |
| Memory size | 2.6 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 9.9869859 |
| Min length | 4 |
Unique
| Unique | 4023 ? |
|---|---|
| Unique (%) | 28.0% |
Sample
| 1st row | REQ0011118 |
|---|---|
| 2nd row | REQ0011932 |
| 3rd row | REQ0011476 |
| 4th row | REQ0013911 |
| 5th row | REQ0014515 |
| Value | Count | Frequency (%) |
| req0008872 | 123 | 0.9% |
| req0010655 | 81 | 0.6% |
| req0009177 | 65 | 0.5% |
| req0010201 | 62 | 0.4% |
| req0008985 | 59 | 0.4% |
| req0008405 | 55 | 0.4% |
| req0010705 | 51 | 0.4% |
| req0009336 | 51 | 0.4% |
| req0010418 | 49 | 0.3% |
| req0010689 | 39 | 0.3% |
| Other values (5984) | 13734 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 38895 | |
| 1 | 17527 | |
| R | 14323 | 10.0% |
| E | 14075 | 9.8% |
| Q | 14023 | 9.8% |
| 9 | 6459 | 4.5% |
| 2 | 6183 | 4.3% |
| 3 | 6070 | 4.2% |
| 4 | 5547 | 3.9% |
| 8 | 4991 | 3.5% |
| Other values (31) | 15410 | 10.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 143503 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 38895 | |
| 1 | 17527 | |
| R | 14323 | 10.0% |
| E | 14075 | 9.8% |
| Q | 14023 | 9.8% |
| 9 | 6459 | 4.5% |
| 2 | 6183 | 4.3% |
| 3 | 6070 | 4.2% |
| 4 | 5547 | 3.9% |
| 8 | 4991 | 3.5% |
| Other values (31) | 15410 | 10.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 143503 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 38895 | |
| 1 | 17527 | |
| R | 14323 | 10.0% |
| E | 14075 | 9.8% |
| Q | 14023 | 9.8% |
| 9 | 6459 | 4.5% |
| 2 | 6183 | 4.3% |
| 3 | 6070 | 4.2% |
| 4 | 5547 | 3.9% |
| 8 | 4991 | 3.5% |
| Other values (31) | 15410 | 10.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 143503 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 38895 | |
| 1 | 17527 | |
| R | 14323 | 10.0% |
| E | 14075 | 9.8% |
| Q | 14023 | 9.8% |
| 9 | 6459 | 4.5% |
| 2 | 6183 | 4.3% |
| 3 | 6070 | 4.2% |
| 4 | 5547 | 3.9% |
| 8 | 4991 | 3.5% |
| Other values (31) | 15410 | 10.7% |
Acquisition Type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| NON-IT Goods | |
|---|---|
| NON-IT Services | |
| IT Goods | |
| IT Services | 11516 |
| IT Telecommunications | 147 |
Length
| Max length | 21 |
|---|---|
| Median length | 12 |
| Mean length | 11.974923 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IT Goods |
|---|---|
| 2nd row | NON-IT Goods |
| 3rd row | IT Services |
| 4th row | NON-IT Goods |
| 5th row | NON-IT Goods |
Common Values
| Value | Count | Frequency (%) |
| NON-IT Goods | 215083 | |
| NON-IT Services | 68372 | 19.8% |
| IT Goods | 50900 | 14.7% |
| IT Services | 11516 | 3.3% |
| IT Telecommunications | 147 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| non-it | 283455 | |
| goods | 265983 | |
| services | 79888 | 11.5% |
| it | 62563 | 9.0% |
| telecommunications | 147 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 566910 | |
| o | 532260 | |
| T | 346165 | |
| I | 346018 | |
| 346018 | ||
| s | 346018 | |
| O | 283455 | |
| - | 283455 | |
| G | 265983 | |
| d | 265983 | |
| Other values (12) | 561274 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4143539 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 566910 | |
| o | 532260 | |
| T | 346165 | |
| I | 346018 | |
| 346018 | ||
| s | 346018 | |
| O | 283455 | |
| - | 283455 | |
| G | 265983 | |
| d | 265983 | |
| Other values (12) | 561274 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4143539 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 566910 | |
| o | 532260 | |
| T | 346165 | |
| I | 346018 | |
| 346018 | ||
| s | 346018 | |
| O | 283455 | |
| - | 283455 | |
| G | 265983 | |
| d | 265983 | |
| Other values (12) | 561274 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4143539 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 566910 | |
| o | 532260 | |
| T | 346165 | |
| I | 346018 | |
| 346018 | ||
| s | 346018 | |
| O | 283455 | |
| - | 283455 | |
| G | 265983 | |
| d | 265983 | |
| Other values (12) | 561274 |
Sub-Acquisition Type
Categorical
Missing 
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 277681 |
| Missing (%) | 80.3% |
| Memory size | 2.6 MiB |
| Personal Services | |
|---|---|
| Services are specifically exempt by statute | |
| Emergency Contract | |
| Subvention and Local Assistance | |
| Public Works | |
| Other values (20) |
Length
| Max length | 67 |
|---|---|
| Median length | 43 |
| Mean length | 25.958397 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Personal Services |
|---|---|
| 2nd row | Personal Services |
| 3rd row | Legal Services |
| 4th row | Legal Services |
| 5th row | Legal Services |
Common Values
| Value | Count | Frequency (%) |
| Personal Services | 16104 | 4.7% |
| Services are specifically exempt by statute | 11854 | 3.4% |
| Emergency Contract | 7913 | 2.3% |
| Subvention and Local Assistance | 7048 | 2.0% |
| Public Works | 4791 | 1.4% |
| Expert Witneses | 3800 | 1.1% |
| Interagency Agreements | 3261 | 0.9% |
| Agreements with other governmental entities and public universities | 2051 | 0.6% |
| Architectural and Engineering | 1785 | 0.5% |
| Contracts with Local Governments | 1562 | 0.5% |
| Other values (15) | 8168 | 2.4% |
| (Missing) | 277681 |
Length
| Value | Count | Frequency (%) |
| services | 32201 | 14.4% |
| personal | 16104 | 7.2% |
| and | 12477 | 5.6% |
| are | 11854 | 5.3% |
| specifically | 11854 | 5.3% |
| exempt | 11854 | 5.3% |
| by | 11854 | 5.3% |
| statute | 11854 | 5.3% |
| local | 8610 | 3.9% |
| emergency | 7913 | 3.5% |
| Other values (51) | 87054 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 237220 | |
| 155292 | 8.8% | |
| s | 127181 | 7.2% |
| t | 125370 | 7.1% |
| n | 115940 | 6.5% |
| i | 115867 | 6.5% |
| r | 115471 | 6.5% |
| a | 105019 | 5.9% |
| c | 103985 | 5.9% |
| l | 65656 | 3.7% |
| Other values (34) | 506918 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1773919 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 237220 | |
| 155292 | 8.8% | |
| s | 127181 | 7.2% |
| t | 125370 | 7.1% |
| n | 115940 | 6.5% |
| i | 115867 | 6.5% |
| r | 115471 | 6.5% |
| a | 105019 | 5.9% |
| c | 103985 | 5.9% |
| l | 65656 | 3.7% |
| Other values (34) | 506918 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1773919 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 237220 | |
| 155292 | 8.8% | |
| s | 127181 | 7.2% |
| t | 125370 | 7.1% |
| n | 115940 | 6.5% |
| i | 115867 | 6.5% |
| r | 115471 | 6.5% |
| a | 105019 | 5.9% |
| c | 103985 | 5.9% |
| l | 65656 | 3.7% |
| Other values (34) | 506918 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1773919 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 237220 | |
| 155292 | 8.8% | |
| s | 127181 | 7.2% |
| t | 125370 | 7.1% |
| n | 115940 | 6.5% |
| i | 115867 | 6.5% |
| r | 115471 | 6.5% |
| a | 105019 | 5.9% |
| c | 103985 | 5.9% |
| l | 65656 | 3.7% |
| Other values (34) | 506918 |
Acquisition Method
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Informal Competitive | |
|---|---|
| Statewide Contract | |
| SB/DVBE Option | |
| Services are specifically exempt by statute | |
| State Programs | |
| Other values (15) |
Length
| Max length | 43 |
|---|---|
| Median length | 42 |
| Mean length | 20.229682 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WSCA/Coop |
|---|---|
| 2nd row | Informal Competitive |
| 3rd row | Informal Competitive |
| 4th row | Informal Competitive |
| 5th row | Statewide Contract |
Common Values
| Value | Count | Frequency (%) |
| Informal Competitive | 82083 | |
| Statewide Contract | 63488 | |
| SB/DVBE Option | 38500 | |
| Services are specifically exempt by statute | 33045 | |
| State Programs | 27842 | 8.0% |
| Fair and Reasonable | 25400 | 7.3% |
| WSCA/Coop | 19478 | 5.6% |
| Formal Competitive | 18479 | 5.3% |
| Services are specifically exempt by policy | 11302 | 3.3% |
| Emergency Purchase | 10186 | 2.9% |
| Other values (10) | 16215 | 4.7% |
Length
| Value | Count | Frequency (%) |
| competitive | 100562 | 11.5% |
| informal | 82083 | 9.4% |
| statewide | 63488 | 7.3% |
| contract | 63488 | 7.3% |
| are | 44347 | 5.1% |
| exempt | 44347 | 5.1% |
| specifically | 44347 | 5.1% |
| by | 44347 | 5.1% |
| services | 44347 | 5.1% |
| option | 38500 | 4.4% |
| Other values (32) | 304130 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 769414 | 11.0% |
| t | 706065 | 10.1% |
| a | 529084 | 7.6% |
| 527968 | 7.5% | |
| i | 481038 | 6.9% |
| o | 412281 | 5.9% |
| r | 373842 | 5.3% |
| m | 289832 | 4.1% |
| p | 259213 | 3.7% |
| n | 251937 | 3.6% |
| Other values (34) | 2399160 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6999834 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 769414 | 11.0% |
| t | 706065 | 10.1% |
| a | 529084 | 7.6% |
| 527968 | 7.5% | |
| i | 481038 | 6.9% |
| o | 412281 | 5.9% |
| r | 373842 | 5.3% |
| m | 289832 | 4.1% |
| p | 259213 | 3.7% |
| n | 251937 | 3.6% |
| Other values (34) | 2399160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6999834 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 769414 | 11.0% |
| t | 706065 | 10.1% |
| a | 529084 | 7.6% |
| 527968 | 7.5% | |
| i | 481038 | 6.9% |
| o | 412281 | 5.9% |
| r | 373842 | 5.3% |
| m | 289832 | 4.1% |
| p | 259213 | 3.7% |
| n | 251937 | 3.6% |
| Other values (34) | 2399160 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6999834 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 769414 | 11.0% |
| t | 706065 | 10.1% |
| a | 529084 | 7.6% |
| 527968 | 7.5% | |
| i | 481038 | 6.9% |
| o | 412281 | 5.9% |
| r | 373842 | 5.3% |
| m | 289832 | 4.1% |
| p | 259213 | 3.7% |
| n | 251937 | 3.6% |
| Other values (34) | 2399160 |
Sub-Acquisition Method
Categorical
Imbalance  Missing 
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 315122 |
| Missing (%) | 91.1% |
| Memory size | 2.6 MiB |
| Fleet | |
|---|---|
| Prison Industry Authority (PIA) | |
| Only goods and services that meet needs of the State | |
| Office of State Printing (OSP) | 812 |
| Interagency Agreement | 565 |
| Other values (11) |
Length
| Max length | 58 |
|---|---|
| Median length | 56 |
| Mean length | 20.272333 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Other |
|---|---|
| 2nd row | Prison Industry Authority (PIA) |
| 3rd row | Prison Industry Authority (PIA) |
| 4th row | Prison Industry Authority (PIA) |
| 5th row | Prison Industry Authority (PIA) |
Common Values
| Value | Count | Frequency (%) |
| Fleet | 14148 | 4.1% |
| Prison Industry Authority (PIA) | 11602 | 3.4% |
| Only goods and services that meet needs of the State | 1810 | 0.5% |
| Office of State Printing (OSP) | 812 | 0.2% |
| Interagency Agreement | 565 | 0.2% |
| Services are specifically exempt by statute | 521 | 0.2% |
| Other | 503 | 0.1% |
| Emergency acquisition for the protection of the public | 334 | 0.1% |
| A single firm services a geographic region | 328 | 0.1% |
| Contract with other government agency | 117 | < 0.1% |
| Other values (6) | 156 | < 0.1% |
| (Missing) | 315122 |
Length
| Value | Count | Frequency (%) |
| fleet | 14148 | |
| authority | 11602 | |
| pia | 11602 | |
| prison | 11602 | |
| industry | 11602 | |
| of | 2956 | 3.2% |
| services | 2677 | 2.9% |
| state | 2622 | 2.8% |
| the | 2478 | 2.6% |
| and | 1810 | 1.9% |
| Other values (50) | 20502 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 68653 | 11.0% |
| 62705 | 10.0% | |
| e | 55519 | 8.9% |
| r | 42991 | 6.9% |
| n | 34477 | 5.5% |
| s | 33452 | 5.3% |
| i | 32734 | 5.2% |
| o | 32392 | 5.2% |
| y | 27164 | 4.3% |
| P | 24828 | 4.0% |
| Other values (33) | 211419 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 626334 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 68653 | 11.0% |
| 62705 | 10.0% | |
| e | 55519 | 8.9% |
| r | 42991 | 6.9% |
| n | 34477 | 5.5% |
| s | 33452 | 5.3% |
| i | 32734 | 5.2% |
| o | 32392 | 5.2% |
| y | 27164 | 4.3% |
| P | 24828 | 4.0% |
| Other values (33) | 211419 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 626334 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 68653 | 11.0% |
| 62705 | 10.0% | |
| e | 55519 | 8.9% |
| r | 42991 | 6.9% |
| n | 34477 | 5.5% |
| s | 33452 | 5.3% |
| i | 32734 | 5.2% |
| o | 32392 | 5.2% |
| y | 27164 | 4.3% |
| P | 24828 | 4.0% |
| Other values (33) | 211419 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 626334 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 68653 | 11.0% |
| 62705 | 10.0% | |
| e | 55519 | 8.9% |
| r | 42991 | 6.9% |
| n | 34477 | 5.5% |
| s | 33452 | 5.3% |
| i | 32734 | 5.2% |
| o | 32392 | 5.2% |
| y | 27164 | 4.3% |
| P | 24828 | 4.0% |
| Other values (33) | 211419 |
Department Name
Text
| Distinct | 111 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 59 |
|---|---|
| Median length | 51 |
| Mean length | 34.360594 |
| Min length | 17 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Consumer Affairs, Department of |
|---|---|
| 2nd row | Consumer Affairs, Department of |
| 3rd row | Consumer Affairs, Department of |
| 4th row | Correctional Health Care Services |
| 5th row | Corrections and Rehabilitation, Department of |
| Value | Count | Frequency (%) |
| of | 272314 | |
| department | 265129 | |
| and | 95652 | 6.5% |
| services | 63459 | 4.3% |
| rehabilitation | 59821 | 4.0% |
| corrections | 57557 | 3.9% |
| health | 49030 | 3.3% |
| care | 35715 | 2.4% |
| resources | 33370 | 2.3% |
| correctional | 32250 | 2.2% |
| Other values (171) | 515655 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1355089 | 11.4% |
| t | 1140741 | 9.6% |
| 1133934 | 9.5% | |
| a | 932131 | 7.8% |
| r | 907190 | 7.6% |
| o | 849147 | 7.1% |
| n | 769164 | 6.5% |
| i | 659960 | 5.6% |
| s | 390801 | 3.3% |
| f | 359306 | 3.0% |
| Other values (40) | 3391921 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11889384 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1355089 | 11.4% |
| t | 1140741 | 9.6% |
| 1133934 | 9.5% | |
| a | 932131 | 7.8% |
| r | 907190 | 7.6% |
| o | 849147 | 7.1% |
| n | 769164 | 6.5% |
| i | 659960 | 5.6% |
| s | 390801 | 3.3% |
| f | 359306 | 3.0% |
| Other values (40) | 3391921 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11889384 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1355089 | 11.4% |
| t | 1140741 | 9.6% |
| 1133934 | 9.5% | |
| a | 932131 | 7.8% |
| r | 907190 | 7.6% |
| o | 849147 | 7.1% |
| n | 769164 | 6.5% |
| i | 659960 | 5.6% |
| s | 390801 | 3.3% |
| f | 359306 | 3.0% |
| Other values (40) | 3391921 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11889384 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1355089 | 11.4% |
| t | 1140741 | 9.6% |
| 1133934 | 9.5% | |
| a | 932131 | 7.8% |
| r | 907190 | 7.6% |
| o | 849147 | 7.1% |
| n | 769164 | 6.5% |
| i | 659960 | 5.6% |
| s | 390801 | 3.3% |
| f | 359306 | 3.0% |
| Other values (40) | 3391921 |
Supplier Code
Real number (ℝ)
Skewed  Zeros 
| Distinct | 25239 |
|---|---|
| Distinct (%) | 7.3% |
| Missing | 36 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 843434.48 |
| Minimum | 0 |
|---|---|
| Maximum | 9.5483178 × 108 |
| Zeros | 4473 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6509 |
| Q1 | 27292 |
| median | 1012531 |
| Q3 | 1482180 |
| 95-th percentile | 1757013 |
| Maximum | 9.5483178 × 108 |
| Range | 9.5483178 × 108 |
| Interquartile range (IQR) | 1454888 |
Descriptive statistics
| Standard deviation | 2461186.2 |
|---|---|
| Coefficient of variation (CV) | 2.9180526 |
| Kurtosis | 131365.99 |
| Mean | 843434.48 |
| Median Absolute Deviation (MAD) | 738209 |
| Skewness | 343.48217 |
| Sum | 2.9181315 × 1011 |
| Variance | 6.0574375 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1743406 | 13756 | 4.0% |
| 1001584 | 9441 | 2.7% |
| 1065902 | 8508 | 2.5% |
| 1008361 | 6991 | 2.0% |
| 1087660 | 6709 | 1.9% |
| 17224 | 5979 | 1.7% |
| 1755386 | 5033 | 1.5% |
| 0 | 4473 | 1.3% |
| 12341 | 3983 | 1.2% |
| 1752319 | 3625 | 1.0% |
| Other values (25229) | 277484 |
| Value | Count | Frequency (%) |
| 0 | 4473 | |
| 15 | 2 | < 0.1% |
| 39 | 377 | 0.1% |
| 42 | 3 | < 0.1% |
| 45 | 1 | < 0.1% |
| 49 | 1 | < 0.1% |
| 61 | 69 | < 0.1% |
| 89 | 8 | < 0.1% |
| 114 | 1 | < 0.1% |
| 123 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 954831781 | 1 | < 0.1% |
| 954650312 | 1 | < 0.1% |
| 330284668 | 1 | < 0.1% |
| 1796774 | 6 | |
| 1796486 | 8 | |
| 1795780 | 4 | < 0.1% |
| 1795272 | 10 | |
| 1794552 | 4 | < 0.1% |
| 1794147 | 9 | |
| 1793858 | 1 | < 0.1% |
Supplier Name
Text
| Distinct | 24732 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 36 |
| Missing (%) | < 0.1% |
| Memory size | 2.6 MiB |
Length
| Max length | 80 |
|---|---|
| Median length | 72 |
| Mean length | 23.540043 |
| Min length | 3 |
Unique
| Unique | 10435 ? |
|---|---|
| Unique (%) | 3.0% |
Sample
| 1st row | Pitney Bowes |
|---|---|
| 2nd row | Rodea Auto Tech |
| 3rd row | Smile Business Products, Inc |
| 4th row | ASHAN INC |
| 5th row | Technology Integration Group |
| Value | Count | Frequency (%) |
| inc | 124185 | 10.8% |
| supply | 26861 | 2.3% |
| systems | 23263 | 2.0% |
| 20226 | 1.8% | |
| group | 14933 | 1.3% |
| industrial | 14889 | 1.3% |
| of | 14740 | 1.3% |
| office | 14500 | 1.3% |
| fleet | 14274 | 1.2% |
| business | 14114 | 1.2% |
| Other values (18509) | 872395 |
Most occurring characters
| Value | Count | Frequency (%) |
| 808663 | 9.9% | |
| e | 514076 | 6.3% |
| n | 495074 | 6.1% |
| r | 394831 | 4.8% |
| o | 393995 | 4.8% |
| i | 381051 | 4.7% |
| t | 377055 | 4.6% |
| s | 345353 | 4.2% |
| a | 324608 | 4.0% |
| I | 295467 | 3.6% |
| Other values (76) | 3814258 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8144431 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 808663 | 9.9% | |
| e | 514076 | 6.3% |
| n | 495074 | 6.1% |
| r | 394831 | 4.8% |
| o | 393995 | 4.8% |
| i | 381051 | 4.7% |
| t | 377055 | 4.6% |
| s | 345353 | 4.2% |
| a | 324608 | 4.0% |
| I | 295467 | 3.6% |
| Other values (76) | 3814258 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8144431 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 808663 | 9.9% | |
| e | 514076 | 6.3% |
| n | 495074 | 6.1% |
| r | 394831 | 4.8% |
| o | 393995 | 4.8% |
| i | 381051 | 4.7% |
| t | 377055 | 4.6% |
| s | 345353 | 4.2% |
| a | 324608 | 4.0% |
| I | 295467 | 3.6% |
| Other values (76) | 3814258 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8144431 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 808663 | 9.9% | |
| e | 514076 | 6.3% |
| n | 495074 | 6.1% |
| r | 394831 | 4.8% |
| o | 393995 | 4.8% |
| i | 381051 | 4.7% |
| t | 377055 | 4.6% |
| s | 345353 | 4.2% |
| a | 324608 | 4.0% |
| I | 295467 | 3.6% |
| Other values (76) | 3814258 |
Missing 
| Distinct | 278 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 204273 |
| Missing (%) | 59.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 62 |
|---|---|
| Median length | 57 |
| Mean length | 12.242287 |
| Min length | 2 |
Unique
| Unique | 62 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CA-MB CA-SB |
|---|---|
| 2nd row | CA-MB CA-SB |
| 3rd row | CA-DVBE CA-MB CA-SB CDVBE |
| 4th row | CA-SB |
| 5th row | CA-MB CA-SB |
| Value | Count | Frequency (%) |
| ca-sb | 133608 | |
| ca-mb | 79876 | |
| ca-sbe | 29408 | 9.4% |
| ca-dvbe | 21146 | 6.7% |
| sb | 19399 | 6.2% |
| cdvbe | 11313 | 3.6% |
| wbe | 4519 | 1.4% |
| sdvosb | 3219 | 1.0% |
| wosb | 3003 | 1.0% |
| mbe | 2708 | 0.9% |
| Other values (6) | 5170 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 312875 | |
| C | 276125 | |
| A | 265092 | |
| - | 264812 | |
| S | 194049 | |
| 171624 | ||
| M | 84217 | 4.9% |
| E | 71577 | 4.1% |
| D | 38441 | 2.2% |
| V | 36661 | 2.1% |
| Other values (8) | 19810 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1735283 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 312875 | |
| C | 276125 | |
| A | 265092 | |
| - | 264812 | |
| S | 194049 | |
| 171624 | ||
| M | 84217 | 4.9% |
| E | 71577 | 4.1% |
| D | 38441 | 2.2% |
| V | 36661 | 2.1% |
| Other values (8) | 19810 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1735283 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 312875 | |
| C | 276125 | |
| A | 265092 | |
| - | 264812 | |
| S | 194049 | |
| 171624 | ||
| M | 84217 | 4.9% |
| E | 71577 | 4.1% |
| D | 38441 | 2.2% |
| V | 36661 | 2.1% |
| Other values (8) | 19810 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1735283 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 312875 | |
| C | 276125 | |
| A | 265092 | |
| - | 264812 | |
| S | 194049 | |
| 171624 | ||
| M | 84217 | 4.9% |
| E | 71577 | 4.1% |
| D | 38441 | 2.2% |
| V | 36661 | 2.1% |
| Other values (8) | 19810 | 1.1% |
Missing 
| Distinct | 3993 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 70110 |
| Missing (%) | 20.3% |
| Memory size | 2.6 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 5 |
| Mean length | 5.1999906 |
| Min length | 3 |
Unique
| Unique | 742 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 95841 |
|---|---|
| 2nd row | 91436 |
| 3rd row | 95814 |
| 4th row | 97008 |
| 5th row | 95814 |
| Value | Count | Frequency (%) |
| 95691 | 11095 | 4.0% |
| 95814 | 10921 | 4.0% |
| 95696 | 8518 | 3.1% |
| 95827 | 7159 | 2.6% |
| 95841 | 7008 | 2.5% |
| 73529 | 6991 | 2.5% |
| 95742 | 5676 | 2.1% |
| 95811 | 4779 | 1.7% |
| 93706 | 4412 | 1.6% |
| 92653 | 4027 | 1.5% |
| Other values (4007) | 205462 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 305406 | |
| 5 | 193463 | |
| 1 | 149128 | |
| 6 | 129810 | |
| 0 | 126572 | |
| 2 | 118545 | 8.3% |
| 3 | 110956 | 7.7% |
| 4 | 105718 | 7.4% |
| 8 | 93727 | 6.5% |
| 7 | 88950 | 6.2% |
| Other values (31) | 12444 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1434719 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 305406 | |
| 5 | 193463 | |
| 1 | 149128 | |
| 6 | 129810 | |
| 0 | 126572 | |
| 2 | 118545 | 8.3% |
| 3 | 110956 | 7.7% |
| 4 | 105718 | 7.4% |
| 8 | 93727 | 6.5% |
| 7 | 88950 | 6.2% |
| Other values (31) | 12444 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1434719 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 305406 | |
| 5 | 193463 | |
| 1 | 149128 | |
| 6 | 129810 | |
| 0 | 126572 | |
| 2 | 118545 | 8.3% |
| 3 | 110956 | 7.7% |
| 4 | 105718 | 7.4% |
| 8 | 93727 | 6.5% |
| 7 | 88950 | 6.2% |
| Other values (31) | 12444 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1434719 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 305406 | |
| 5 | 193463 | |
| 1 | 149128 | |
| 6 | 129810 | |
| 0 | 126572 | |
| 2 | 118545 | 8.3% |
| 3 | 110956 | 7.7% |
| 4 | 105718 | 7.4% |
| 8 | 93727 | 6.5% |
| 7 | 88950 | 6.2% |
| Other values (31) | 12444 | 0.9% |
CalCard
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.0 KiB |
| False | |
|---|---|
| True | 5372 |
| Value | Count | Frequency (%) |
| False | 340646 | |
| True | 5372 | 1.6% |
Item Name
Text
| Distinct | 180029 |
|---|---|
| Distinct (%) | 52.0% |
| Missing | 32 |
| Missing (%) | < 0.1% |
| Memory size | 2.6 MiB |
Length
| Max length | 101 |
|---|---|
| Median length | 81 |
| Mean length | 22.547808 |
| Min length | 1 |
Unique
| Unique | 151218 ? |
|---|---|
| Unique (%) | 43.7% |
Sample
| 1st row | USB |
|---|---|
| 2nd row | Tire Disposal |
| 3rd row | Labor |
| 4th row | Toner |
| 5th row | HP 35A BLACK TONER |
| Value | Count | Frequency (%) |
| for | 24932 | 2.2% |
| 17809 | 1.5% | |
| services | 15568 | 1.3% |
| equip | 13811 | 1.2% |
| fuel | 13340 | 1.2% |
| and | 12349 | 1.1% |
| supplies | 11452 | 1.0% |
| maintenance | 9254 | 0.8% |
| medical | 7579 | 0.7% |
| hp | 7018 | 0.6% |
| Other values (82436) | 1025214 |
Most occurring characters
| Value | Count | Frequency (%) |
| 815972 | 10.5% | |
| e | 573975 | 7.4% |
| r | 378780 | 4.9% |
| a | 370956 | 4.8% |
| i | 356300 | 4.6% |
| n | 319439 | 4.1% |
| t | 317283 | 4.1% |
| o | 304368 | 3.9% |
| s | 253119 | 3.2% |
| l | 229373 | 2.9% |
| Other values (113) | 3881661 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7801226 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 815972 | 10.5% | |
| e | 573975 | 7.4% |
| r | 378780 | 4.9% |
| a | 370956 | 4.8% |
| i | 356300 | 4.6% |
| n | 319439 | 4.1% |
| t | 317283 | 4.1% |
| o | 304368 | 3.9% |
| s | 253119 | 3.2% |
| l | 229373 | 2.9% |
| Other values (113) | 3881661 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7801226 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 815972 | 10.5% | |
| e | 573975 | 7.4% |
| r | 378780 | 4.9% |
| a | 370956 | 4.8% |
| i | 356300 | 4.6% |
| n | 319439 | 4.1% |
| t | 317283 | 4.1% |
| o | 304368 | 3.9% |
| s | 253119 | 3.2% |
| l | 229373 | 2.9% |
| Other values (113) | 3881661 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7801226 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 815972 | 10.5% | |
| e | 573975 | 7.4% |
| r | 378780 | 4.9% |
| a | 370956 | 4.8% |
| i | 356300 | 4.6% |
| n | 319439 | 4.1% |
| t | 317283 | 4.1% |
| o | 304368 | 3.9% |
| s | 253119 | 3.2% |
| l | 229373 | 2.9% |
| Other values (113) | 3881661 |
Item Description
Text
| Distinct | 219508 |
|---|---|
| Distinct (%) | 63.5% |
| Missing | 202 |
| Missing (%) | 0.1% |
| Memory size | 2.6 MiB |
Length
| Max length | 3380 |
|---|---|
| Median length | 1707 |
| Mean length | 41.868366 |
| Min length | 1 |
Unique
| Unique | 195325 ? |
|---|---|
| Unique (%) | 56.5% |
Sample
| 1st row | USB |
|---|---|
| 2nd row | Tire Disposal |
| 3rd row | Labor |
| 4th row | Toner |
| 5th row | HP 35A BLACK TONER |
| Value | Count | Frequency (%) |
| for | 53923 | 2.5% |
| and | 42931 | 2.0% |
| the | 34091 | 1.6% |
| to | 33522 | 1.6% |
| 29903 | 1.4% | |
| of | 24985 | 1.2% |
| services | 20629 | 1.0% |
| fuel | 13921 | 0.6% |
| equip | 13819 | 0.6% |
| provide | 12904 | 0.6% |
| Other values (139566) | 1877652 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1867193 | 12.9% | |
| e | 1035864 | 7.2% |
| a | 695956 | 4.8% |
| r | 682223 | 4.7% |
| i | 661077 | 4.6% |
| t | 653680 | 4.5% |
| o | 627712 | 4.3% |
| n | 623075 | 4.3% |
| s | 491782 | 3.4% |
| l | 396589 | 2.7% |
| Other values (121) | 6743600 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14478751 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1867193 | 12.9% | |
| e | 1035864 | 7.2% |
| a | 695956 | 4.8% |
| r | 682223 | 4.7% |
| i | 661077 | 4.6% |
| t | 653680 | 4.5% |
| o | 627712 | 4.3% |
| n | 623075 | 4.3% |
| s | 491782 | 3.4% |
| l | 396589 | 2.7% |
| Other values (121) | 6743600 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14478751 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1867193 | 12.9% | |
| e | 1035864 | 7.2% |
| a | 695956 | 4.8% |
| r | 682223 | 4.7% |
| i | 661077 | 4.6% |
| t | 653680 | 4.5% |
| o | 627712 | 4.3% |
| n | 623075 | 4.3% |
| s | 491782 | 3.4% |
| l | 396589 | 2.7% |
| Other values (121) | 6743600 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14478751 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1867193 | 12.9% | |
| e | 1035864 | 7.2% |
| a | 695956 | 4.8% |
| r | 682223 | 4.7% |
| i | 661077 | 4.6% |
| t | 653680 | 4.5% |
| o | 627712 | 4.3% |
| n | 623075 | 4.3% |
| s | 491782 | 3.4% |
| l | 396589 | 2.7% |
| Other values (121) | 6743600 |
Quantity
Real number (ℝ)
Skewed 
| Distinct | 6131 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 30 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2316.1537 |
| Minimum | 0.0001 |
|---|---|
| Maximum | 20000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0.0001 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 6 |
| 95-th percentile | 775 |
| Maximum | 20000000 |
| Range | 20000000 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 105825.91 |
|---|---|
| Coefficient of variation (CV) | 45.690367 |
| Kurtosis | 16998.127 |
| Mean | 2316.1537 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 117.44829 |
| Sum | 8.0136137 × 108 |
| Variance | 1.1199123 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 214019 | |
| 2 | 18383 | 5.3% |
| 4 | 8794 | 2.5% |
| 3 | 8288 | 2.4% |
| 10 | 7053 | 2.0% |
| 5 | 6377 | 1.8% |
| 6 | 5852 | 1.7% |
| 20 | 4108 | 1.2% |
| 12 | 3756 | 1.1% |
| 8 | 3343 | 1.0% |
| Other values (6121) | 66015 | 19.1% |
| Value | Count | Frequency (%) |
| 0.0001 | 2 | < 0.1% |
| 0.004 | 1 | < 0.1% |
| 0.0055 | 1 | < 0.1% |
| 0.01 | 5 | |
| 0.0102 | 1 | < 0.1% |
| 0.0113 | 1 | < 0.1% |
| 0.1 | 8 | |
| 0.13 | 1 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.18 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 20000000 | 2 | |
| 18000000 | 1 | < 0.1% |
| 15000000 | 4 | |
| 12000000 | 2 | |
| 10000000 | 1 | < 0.1% |
| 9750000 | 1 | < 0.1% |
| 9408000 | 1 | < 0.1% |
| 9000000 | 2 | |
| 8250000 | 2 | |
| 6545000 | 1 | < 0.1% |
Unit Price
Text
| Distinct | 128167 |
|---|---|
| Distinct (%) | 37.0% |
| Missing | 30 |
| Missing (%) | < 0.1% |
| Memory size | 2.6 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 7.3313005 |
| Min length | 5 |
Unique
| Unique | 99844 ? |
|---|---|
| Unique (%) | 28.9% |
Sample
| 1st row | $1.00 |
|---|---|
| 2nd row | $2.00 |
| 3rd row | $150.00 |
| 4th row | $6080.26 |
| 5th row | $45.40 |
| Value | Count | Frequency (%) |
| 0.00 | 7552 | 2.2% |
| 1.00 | 3616 | 1.0% |
| 10000.00 | 2207 | 0.6% |
| 50000.00 | 1226 | 0.4% |
| 4.00 | 1140 | 0.3% |
| 15000.00 | 1052 | 0.3% |
| 20000.00 | 946 | 0.3% |
| 30000.00 | 941 | 0.3% |
| 25000.00 | 923 | 0.3% |
| 1.75 | 865 | 0.3% |
| Other values (127648) | 325520 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 560208 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 198799 | 7.8% |
| 5 | 170454 | 6.7% |
| 2 | 164405 | 6.5% |
| 4 | 133584 | 5.3% |
| 9 | 131910 | 5.2% |
| 3 | 131539 | 5.2% |
| 6 | 122750 | 4.8% |
| Other values (3) | 230917 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2536542 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 560208 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 198799 | 7.8% |
| 5 | 170454 | 6.7% |
| 2 | 164405 | 6.5% |
| 4 | 133584 | 5.3% |
| 9 | 131910 | 5.2% |
| 3 | 131539 | 5.2% |
| 6 | 122750 | 4.8% |
| Other values (3) | 230917 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2536542 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 560208 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 198799 | 7.8% |
| 5 | 170454 | 6.7% |
| 2 | 164405 | 6.5% |
| 4 | 133584 | 5.3% |
| 9 | 131910 | 5.2% |
| 3 | 131539 | 5.2% |
| 6 | 122750 | 4.8% |
| Other values (3) | 230917 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2536542 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 560208 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 198799 | 7.8% |
| 5 | 170454 | 6.7% |
| 2 | 164405 | 6.5% |
| 4 | 133584 | 5.3% |
| 9 | 131910 | 5.2% |
| 3 | 131539 | 5.2% |
| 6 | 122750 | 4.8% |
| Other values (3) | 230917 |
Total Price
Text
| Distinct | 150305 |
|---|---|
| Distinct (%) | 43.4% |
| Missing | 30 |
| Missing (%) | < 0.1% |
| Memory size | 2.6 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 7.857391 |
| Min length | 5 |
Unique
| Unique | 114575 ? |
|---|---|
| Unique (%) | 33.1% |
Sample
| 1st row | $1.00 |
|---|---|
| 2nd row | $4.00 |
| 3rd row | $675.00 |
| 4th row | $6080.26 |
| 5th row | $1362.00 |
| Value | Count | Frequency (%) |
| 0.00 | 7519 | 2.2% |
| 10000.00 | 2292 | 0.7% |
| 50000.00 | 1265 | 0.4% |
| 15000.00 | 1153 | 0.3% |
| 20000.00 | 1008 | 0.3% |
| 30000.00 | 1005 | 0.3% |
| 25000.00 | 969 | 0.3% |
| 40000.00 | 696 | 0.2% |
| 5000.00 | 685 | 0.2% |
| 4999.00 | 616 | 0.2% |
| Other values (149654) | 328780 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 653196 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 200334 | 7.4% |
| 2 | 180568 | 6.6% |
| 5 | 176179 | 6.5% |
| 4 | 151616 | 5.6% |
| 6 | 140811 | 5.2% |
| 3 | 134785 | 5.0% |
| 8 | 134106 | 4.9% |
| Other values (3) | 254992 | 9.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2718563 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 653196 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 200334 | 7.4% |
| 2 | 180568 | 6.6% |
| 5 | 176179 | 6.5% |
| 4 | 151616 | 5.6% |
| 6 | 140811 | 5.2% |
| 3 | 134785 | 5.0% |
| 8 | 134106 | 4.9% |
| Other values (3) | 254992 | 9.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2718563 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 653196 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 200334 | 7.4% |
| 2 | 180568 | 6.6% |
| 5 | 176179 | 6.5% |
| 4 | 151616 | 5.6% |
| 6 | 140811 | 5.2% |
| 3 | 134785 | 5.0% |
| 8 | 134106 | 4.9% |
| Other values (3) | 254992 | 9.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2718563 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 653196 | |
| $ | 345988 | |
| . | 345988 | |
| 1 | 200334 | 7.4% |
| 2 | 180568 | 6.6% |
| 5 | 176179 | 6.5% |
| 4 | 151616 | 5.6% |
| 6 | 140811 | 5.2% |
| 3 | 134785 | 5.0% |
| 8 | 134106 | 4.9% |
| Other values (3) | 254992 | 9.4% |
| Distinct | 46049 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 1017 |
| Missing (%) | 0.3% |
| Memory size | 2.6 MiB |
Length
| Max length | 255 |
|---|---|
| Median length | 8 |
| Mean length | 13.160913 |
| Min length | 6 |
Unique
| Unique | 30678 ? |
|---|---|
| Unique (%) | 8.9% |
Sample
| 1st row | 76121504 |
|---|---|
| 2nd row | 44103127 |
| 3rd row | 44103127 |
| 4th row | 85121615 |
| 5th row | 44103127 |
| Value | Count | Frequency (%) |
| 15101506 | 13313 | 2.5% |
| 44103103 | 7628 | 1.4% |
| 86101605 | 4802 | 0.9% |
| 85101705 | 4297 | 0.8% |
| 81112201 | 4151 | 0.8% |
| 80121903 | 3680 | 0.7% |
| 43211503 | 2807 | 0.5% |
| 44101501 | 2611 | 0.5% |
| 43211507 | 2558 | 0.5% |
| 56101504 | 2551 | 0.5% |
| Other values (16967) | 494789 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1288099 | |
| 0 | 697883 | |
| 2 | 537533 | |
| 4 | 403306 | 8.9% |
| 5 | 403095 | 8.9% |
| 3 | 292989 | 6.5% |
| 6 | 229673 | 5.1% |
| 7 | 203444 | 4.5% |
| 198186 | 4.4% | |
| 8 | 179319 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4540528 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1288099 | |
| 0 | 697883 | |
| 2 | 537533 | |
| 4 | 403306 | 8.9% |
| 5 | 403095 | 8.9% |
| 3 | 292989 | 6.5% |
| 6 | 229673 | 5.1% |
| 7 | 203444 | 4.5% |
| 198186 | 4.4% | |
| 8 | 179319 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4540528 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1288099 | |
| 0 | 697883 | |
| 2 | 537533 | |
| 4 | 403306 | 8.9% |
| 5 | 403095 | 8.9% |
| 3 | 292989 | 6.5% |
| 6 | 229673 | 5.1% |
| 7 | 203444 | 4.5% |
| 198186 | 4.4% | |
| 8 | 179319 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4540528 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1288099 | |
| 0 | 697883 | |
| 2 | 537533 | |
| 4 | 403306 | 8.9% |
| 5 | 403095 | 8.9% |
| 3 | 292989 | 6.5% |
| 6 | 229673 | 5.1% |
| 7 | 203444 | 4.5% |
| 198186 | 4.4% | |
| 8 | 179319 | 3.9% |
Normalized UNSPSC
Real number (ℝ)
| Distinct | 13553 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 1017 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49321974 |
| Minimum | 301817 |
|---|---|
| Maximum | 95141903 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 301817 |
|---|---|
| 5-th percentile | 14111703 |
| Q1 | 39111712 |
| median | 44121604 |
| Q3 | 72101506 |
| 95-th percentile | 86101705 |
| Maximum | 95141903 |
| Range | 94840086 |
| Interquartile range (IQR) | 32989794 |
Descriptive statistics
| Standard deviation | 22469666 |
|---|---|
| Coefficient of variation (CV) | 0.4555711 |
| Kurtosis | -0.80910019 |
| Mean | 49321974 |
| Median Absolute Deviation (MAD) | 12959201 |
| Skewness | 0.27843798 |
| Sum | 1.701613 × 1013 |
| Variance | 5.048859 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15101506 | 12776 | 3.7% |
| 44103103 | 7274 | 2.1% |
| 86101605 | 4783 | 1.4% |
| 85101705 | 4204 | 1.2% |
| 81112201 | 3745 | 1.1% |
| 80121903 | 3625 | 1.0% |
| 43211503 | 2609 | 0.8% |
| 44101501 | 2578 | 0.7% |
| 14111507 | 2456 | 0.7% |
| 56101504 | 2426 | 0.7% |
| Other values (13543) | 298525 |
| Value | Count | Frequency (%) |
| 301817 | 6 | < 0.1% |
| 401723 | 2 | < 0.1% |
| 401726 | 2 | < 0.1% |
| 401728 | 2 | < 0.1% |
| 401729 | 1 | < 0.1% |
| 401733 | 4 | < 0.1% |
| 3018173 | 1 | < 0.1% |
| 10101501 | 1 | < 0.1% |
| 10101502 | 29 | |
| 10101506 | 39 |
| Value | Count | Frequency (%) |
| 95141903 | 289 | |
| 95141902 | 2 | < 0.1% |
| 95141901 | 4 | < 0.1% |
| 95141803 | 26 | < 0.1% |
| 95141802 | 42 | < 0.1% |
| 95141801 | 12 | < 0.1% |
| 95141710 | 1 | < 0.1% |
| 95141708 | 2 | < 0.1% |
| 95141707 | 1 | < 0.1% |
| 95141706 | 4 | < 0.1% |
Commodity Title
Text
| Distinct | 13220 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 3295 |
| Missing (%) | 1.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 119 |
|---|---|
| Median length | 83 |
| Mean length | 24.193153 |
| Min length | 2 |
Unique
| Unique | 3486 ? |
|---|---|
| Unique (%) | 1.0% |
Sample
| 1st row | Jalapeno peppers |
|---|---|
| 2nd row | Ida red apples |
| 3rd row | Magazines |
| 4th row | Hay |
| 5th row | Coffee |
| Value | Count | Frequency (%) |
| or | 113917 | 9.9% |
| services | 35130 | 3.1% |
| maintenance | 15546 | 1.4% |
| service | 14114 | 1.2% |
| gasoline | 12806 | 1.1% |
| petrol | 12776 | 1.1% |
| software | 11858 | 1.0% |
| training | 11688 | 1.0% |
| printer | 11615 | 1.0% |
| medical | 10148 | 0.9% |
| Other values (8077) | 900650 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 903605 | |
| 807525 | 9.7% | |
| r | 683227 | 8.2% |
| s | 612508 | 7.4% |
| i | 605481 | 7.3% |
| o | 561156 | 6.8% |
| a | 537448 | 6.5% |
| t | 525956 | 6.3% |
| n | 487626 | 5.9% |
| c | 353554 | 4.3% |
| Other values (64) | 2213464 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8291550 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 903605 | |
| 807525 | 9.7% | |
| r | 683227 | 8.2% |
| s | 612508 | 7.4% |
| i | 605481 | 7.3% |
| o | 561156 | 6.8% |
| a | 537448 | 6.5% |
| t | 525956 | 6.3% |
| n | 487626 | 5.9% |
| c | 353554 | 4.3% |
| Other values (64) | 2213464 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8291550 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 903605 | |
| 807525 | 9.7% | |
| r | 683227 | 8.2% |
| s | 612508 | 7.4% |
| i | 605481 | 7.3% |
| o | 561156 | 6.8% |
| a | 537448 | 6.5% |
| t | 525956 | 6.3% |
| n | 487626 | 5.9% |
| c | 353554 | 4.3% |
| Other values (64) | 2213464 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8291550 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 903605 | |
| 807525 | 9.7% | |
| r | 683227 | 8.2% |
| s | 612508 | 7.4% |
| i | 605481 | 7.3% |
| o | 561156 | 6.8% |
| a | 537448 | 6.5% |
| t | 525956 | 6.3% |
| n | 487626 | 5.9% |
| c | 353554 | 4.3% |
| Other values (64) | 2213464 |
Class
Real number (ℝ)
| Distinct | 2363 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 3295 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49276328 |
| Minimum | 10101500 |
|---|---|
| Maximum | 95141900 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 10101500 |
|---|---|
| 5-th percentile | 14111700 |
| Q1 | 39111600 |
| median | 44121500 |
| Q3 | 71161100 |
| 95-th percentile | 86101700 |
| Maximum | 95141900 |
| Range | 85040400 |
| Interquartile range (IQR) | 32049500 |
Descriptive statistics
| Standard deviation | 22461054 |
|---|---|
| Coefficient of variation (CV) | 0.45581834 |
| Kurtosis | -0.80593963 |
| Mean | 49276328 |
| Median Absolute Deviation (MAD) | 12959100 |
| Skewness | 0.28204864 |
| Sum | 1.6888131 × 1013 |
| Variance | 5.0449894 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15101500 | 14584 | 4.2% |
| 44103100 | 9457 | 2.7% |
| 14111500 | 7190 | 2.1% |
| 81112200 | 7026 | 2.0% |
| 43211500 | 6974 | 2.0% |
| 86101600 | 4951 | 1.4% |
| 85101700 | 4478 | 1.3% |
| 76122400 | 4458 | 1.3% |
| 81111800 | 4122 | 1.2% |
| 56101500 | 3980 | 1.2% |
| Other values (2353) | 275503 |
| Value | Count | Frequency (%) |
| 10101500 | 100 | < 0.1% |
| 10101600 | 21 | < 0.1% |
| 10101700 | 89 | < 0.1% |
| 10101800 | 7 | < 0.1% |
| 10101900 | 2 | < 0.1% |
| 10111300 | 18 | < 0.1% |
| 10121500 | 95 | < 0.1% |
| 10121600 | 119 | < 0.1% |
| 10121700 | 662 | |
| 10121800 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 95141900 | 295 | |
| 95141800 | 80 | < 0.1% |
| 95141700 | 59 | < 0.1% |
| 95141600 | 10 | < 0.1% |
| 95141500 | 2 | < 0.1% |
| 95131700 | 26 | < 0.1% |
| 95131600 | 134 | |
| 95131500 | 4 | < 0.1% |
| 95122700 | 6 | < 0.1% |
| 95122500 | 4 | < 0.1% |
Class Title
Text
| Distinct | 2360 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 3295 |
| Missing (%) | 1.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 100 |
|---|---|
| Median length | 79 |
| Mean length | 28.290865 |
| Min length | 3 |
Unique
| Unique | 278 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Peppers |
|---|---|
| 2nd row | Apples |
| 3rd row | Printed publications |
| 4th row | Livestock feed |
| 5th row | Coffee and tea |
| Value | Count | Frequency (%) |
| and | 216625 | 17.3% |
| services | 44999 | 3.6% |
| accessories | 25852 | 2.1% |
| equipment | 22218 | 1.8% |
| supplies | 20819 | 1.7% |
| software | 15783 | 1.3% |
| support | 15257 | 1.2% |
| products | 14812 | 1.2% |
| petroleum | 14588 | 1.2% |
| distillates | 14584 | 1.2% |
| Other values (2496) | 844531 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 967534 | 10.0% |
| 907345 | 9.4% | |
| i | 773464 | 8.0% |
| n | 770503 | 7.9% |
| a | 760879 | 7.8% |
| s | 752611 | 7.8% |
| t | 633816 | 6.5% |
| r | 609543 | 6.3% |
| o | 489272 | 5.0% |
| c | 426257 | 4.4% |
| Other values (44) | 2604706 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9695930 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 967534 | 10.0% |
| 907345 | 9.4% | |
| i | 773464 | 8.0% |
| n | 770503 | 7.9% |
| a | 760879 | 7.8% |
| s | 752611 | 7.8% |
| t | 633816 | 6.5% |
| r | 609543 | 6.3% |
| o | 489272 | 5.0% |
| c | 426257 | 4.4% |
| Other values (44) | 2604706 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9695930 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 967534 | 10.0% |
| 907345 | 9.4% | |
| i | 773464 | 8.0% |
| n | 770503 | 7.9% |
| a | 760879 | 7.8% |
| s | 752611 | 7.8% |
| t | 633816 | 6.5% |
| r | 609543 | 6.3% |
| o | 489272 | 5.0% |
| c | 426257 | 4.4% |
| Other values (44) | 2604706 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9695930 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 967534 | 10.0% |
| 907345 | 9.4% | |
| i | 773464 | 8.0% |
| n | 770503 | 7.9% |
| a | 760879 | 7.8% |
| s | 752611 | 7.8% |
| t | 633816 | 6.5% |
| r | 609543 | 6.3% |
| o | 489272 | 5.0% |
| c | 426257 | 4.4% |
| Other values (44) | 2604706 |
Family
Real number (ℝ)
| Distinct | 409 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 3295 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49272189 |
| Minimum | 3018000 |
|---|---|
| Maximum | 95140000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 3018000 |
|---|---|
| 5-th percentile | 14110000 |
| Q1 | 39110000 |
| median | 44120000 |
| Q3 | 71160000 |
| 95-th percentile | 86100000 |
| Maximum | 95140000 |
| Range | 92122000 |
| Interquartile range (IQR) | 32050000 |
Descriptive statistics
| Standard deviation | 22464295 |
|---|---|
| Coefficient of variation (CV) | 0.45592241 |
| Kurtosis | -0.80566174 |
| Mean | 49272189 |
| Median Absolute Deviation (MAD) | 12960000 |
| Skewness | 0.28158343 |
| Sum | 1.6886712 × 1013 |
| Variance | 5.0464456 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44100000 | 16479 | 4.8% |
| 15100000 | 14599 | 4.2% |
| 81110000 | 13946 | 4.0% |
| 43210000 | 13851 | 4.0% |
| 14110000 | 10772 | 3.1% |
| 86100000 | 9785 | 2.8% |
| 44120000 | 9342 | 2.7% |
| 43230000 | 8274 | 2.4% |
| 76120000 | 5433 | 1.6% |
| 56100000 | 5177 | 1.5% |
| Other values (399) | 235065 |
| Value | Count | Frequency (%) |
| 3018000 | 28 | < 0.1% |
| 10100000 | 219 | 0.1% |
| 10110000 | 18 | < 0.1% |
| 10120000 | 891 | |
| 10130000 | 53 | < 0.1% |
| 10140000 | 247 | 0.1% |
| 10150000 | 691 | |
| 10160000 | 66 | < 0.1% |
| 10170000 | 725 | |
| 10190000 | 308 | 0.1% |
| Value | Count | Frequency (%) |
| 95140000 | 446 | |
| 95130000 | 164 | < 0.1% |
| 95120000 | 315 | |
| 95110000 | 14 | < 0.1% |
| 95100000 | 14 | < 0.1% |
| 94130000 | 726 | |
| 94120000 | 65 | < 0.1% |
| 94110000 | 3 | < 0.1% |
| 94100000 | 123 | < 0.1% |
| 93170000 | 5 | < 0.1% |
Family Title
Text
| Distinct | 411 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 3295 |
| Missing (%) | 1.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 87 |
|---|---|
| Median length | 60 |
| Mean length | 29.268721 |
| Min length | 5 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Fresh vegetables |
|---|---|
| 2nd row | Fresh fruits |
| 3rd row | Printed media |
| 4th row | Animal feed |
| 5th row | Beverages |
| Value | Count | Frequency (%) |
| and | 254171 | 19.6% |
| services | 54130 | 4.2% |
| accessories | 49177 | 3.8% |
| equipment | 44553 | 3.4% |
| supplies | 43741 | 3.4% |
| products | 34703 | 2.7% |
| computer | 27797 | 2.1% |
| office | 27745 | 2.1% |
| or | 21073 | 1.6% |
| machines | 16651 | 1.3% |
| Other values (634) | 725216 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1023173 | 10.2% |
| 956234 | 9.5% | |
| a | 788625 | 7.9% |
| i | 775602 | 7.7% |
| s | 774769 | 7.7% |
| n | 773716 | 7.7% |
| r | 630418 | 6.3% |
| t | 600726 | 6.0% |
| o | 505177 | 5.0% |
| c | 470489 | 4.7% |
| Other values (39) | 2732135 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10031064 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1023173 | 10.2% |
| 956234 | 9.5% | |
| a | 788625 | 7.9% |
| i | 775602 | 7.7% |
| s | 774769 | 7.7% |
| n | 773716 | 7.7% |
| r | 630418 | 6.3% |
| t | 600726 | 6.0% |
| o | 505177 | 5.0% |
| c | 470489 | 4.7% |
| Other values (39) | 2732135 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10031064 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1023173 | 10.2% |
| 956234 | 9.5% | |
| a | 788625 | 7.9% |
| i | 775602 | 7.7% |
| s | 774769 | 7.7% |
| n | 773716 | 7.7% |
| r | 630418 | 6.3% |
| t | 600726 | 6.0% |
| o | 505177 | 5.0% |
| c | 470489 | 4.7% |
| Other values (39) | 2732135 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10031064 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1023173 | 10.2% |
| 956234 | 9.5% | |
| a | 788625 | 7.9% |
| i | 775602 | 7.7% |
| s | 774769 | 7.7% |
| n | 773716 | 7.7% |
| r | 630418 | 6.3% |
| t | 600726 | 6.0% |
| o | 505177 | 5.0% |
| c | 470489 | 4.7% |
| Other values (39) | 2732135 |
Segment
Real number (ℝ)
| Distinct | 56 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3295 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49132830 |
| Minimum | 10000000 |
|---|---|
| Maximum | 95000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 10000000 |
|---|---|
| 5-th percentile | 14000000 |
| Q1 | 39000000 |
| median | 44000000 |
| Q3 | 71000000 |
| 95-th percentile | 86000000 |
| Maximum | 95000000 |
| Range | 85000000 |
| Interquartile range (IQR) | 32000000 |
Descriptive statistics
| Standard deviation | 22466364 |
|---|---|
| Coefficient of variation (CV) | 0.45725767 |
| Kurtosis | -0.80651688 |
| Mean | 49132830 |
| Median Absolute Deviation (MAD) | 13000000 |
| Skewness | 0.28463721 |
| Sum | 1.6838951 × 1013 |
| Variance | 5.0473749 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 43000000 | 32681 | 9.4% |
| 50000000 | 27875 | 8.1% |
| 44000000 | 27745 | 8.0% |
| 81000000 | 17350 | 5.0% |
| 42000000 | 16491 | 4.8% |
| 15000000 | 16029 | 4.6% |
| 14000000 | 11235 | 3.2% |
| 25000000 | 10965 | 3.2% |
| 86000000 | 10643 | 3.1% |
| 46000000 | 10196 | 2.9% |
| Other values (46) | 161513 |
| Value | Count | Frequency (%) |
| 10000000 | 3299 | 1.0% |
| 11000000 | 2203 | 0.6% |
| 12000000 | 2402 | 0.7% |
| 13000000 | 504 | 0.1% |
| 14000000 | 11235 | |
| 15000000 | 16029 | |
| 20000000 | 3060 | 0.9% |
| 21000000 | 548 | 0.2% |
| 22000000 | 1372 | 0.4% |
| 23000000 | 2920 | 0.8% |
| Value | Count | Frequency (%) |
| 95000000 | 953 | 0.3% |
| 94000000 | 917 | 0.3% |
| 93000000 | 5724 | |
| 92000000 | 2168 | 0.6% |
| 91000000 | 255 | 0.1% |
| 90000000 | 1515 | 0.4% |
| 86000000 | 10643 | |
| 85000000 | 7977 | |
| 84000000 | 1236 | 0.4% |
| 83000000 | 1733 | 0.5% |
Segment Title
Text
| Distinct | 56 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3295 |
| Missing (%) | 1.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 127 |
|---|---|
| Median length | 70 |
| Mean length | 51.28523 |
| Min length | 18 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Food Beverage and Tobacco Products |
|---|---|
| 2nd row | Food Beverage and Tobacco Products |
| 3rd row | Published Products |
| 4th row | Live Plant and Animal Material and Accessories and Supplies |
| 5th row | Food Beverage and Tobacco Products |
| Value | Count | Frequency (%) |
| and | 674964 | |
| supplies | 100666 | 4.5% |
| accessories | 89765 | 4.0% |
| services | 86795 | 3.8% |
| equipment | 80191 | 3.6% |
| products | 54558 | 2.4% |
| technology | 50031 | 2.2% |
| materials | 36415 | 1.6% |
| components | 35958 | 1.6% |
| information | 32681 | 1.4% |
| Other values (144) | 1014922 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1914223 | 10.9% | |
| n | 1640863 | 9.3% |
| e | 1481553 | 8.4% |
| a | 1447141 | 8.2% |
| i | 1311748 | 7.5% |
| s | 1050829 | 6.0% |
| d | 954285 | 5.4% |
| o | 869130 | 4.9% |
| r | 865549 | 4.9% |
| c | 845799 | 4.8% |
| Other values (36) | 5195508 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17576628 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1914223 | 10.9% | |
| n | 1640863 | 9.3% |
| e | 1481553 | 8.4% |
| a | 1447141 | 8.2% |
| i | 1311748 | 7.5% |
| s | 1050829 | 6.0% |
| d | 954285 | 5.4% |
| o | 869130 | 4.9% |
| r | 865549 | 4.9% |
| c | 845799 | 4.8% |
| Other values (36) | 5195508 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17576628 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1914223 | 10.9% | |
| n | 1640863 | 9.3% |
| e | 1481553 | 8.4% |
| a | 1447141 | 8.2% |
| i | 1311748 | 7.5% |
| s | 1050829 | 6.0% |
| d | 954285 | 5.4% |
| o | 869130 | 4.9% |
| r | 865549 | 4.9% |
| c | 845799 | 4.8% |
| Other values (36) | 5195508 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17576628 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1914223 | 10.9% | |
| n | 1640863 | 9.3% |
| e | 1481553 | 8.4% |
| a | 1447141 | 8.2% |
| i | 1311748 | 7.5% |
| s | 1050829 | 6.0% |
| d | 954285 | 5.4% |
| o | 869130 | 4.9% |
| r | 865549 | 4.9% |
| c | 845799 | 4.8% |
| Other values (36) | 5195508 |
Location
Text
Missing 
| Distinct | 3993 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 70110 |
| Missing (%) | 20.3% |
| Memory size | 2.6 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 30 |
| Mean length | 29.4052 |
| Min length | 4 |
Unique
| Unique | 742 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 95841 (38.662263, -121.346136) |
|---|---|
| 2nd row | 91436 (34.151642, -118.49051) |
| 3rd row | 95814 (38.580427, -121.494396) |
| 4th row | 97008 (45.460518, -122.806409) |
| 5th row | 95814 (38.580427, -121.494396) |
| Value | Count | Frequency (%) |
| 38.575311 | 11643 | 1.4% |
| 121.560401 | 11643 | 1.4% |
| 38.580427 | 11510 | 1.4% |
| 121.494396 | 11510 | 1.4% |
| 95691 | 11095 | 1.4% |
| 95814 | 10921 | 1.3% |
| 122.02 | 8518 | 1.0% |
| 95696 | 8518 | 1.0% |
| 38.43 | 8518 | 1.0% |
| 121.328511 | 7159 | 0.9% |
| Other values (10596) | 720425 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 936712 | |
| 3 | 712585 | 8.8% |
| 9 | 620962 | 7.7% |
| 2 | 608096 | 7.5% |
| 5 | 560846 | 6.9% |
| 8 | 556014 | 6.9% |
| . | 545412 | 6.7% |
| 4 | 523946 | 6.5% |
| 7 | 502781 | 6.2% |
| 6 | 483033 | 6.0% |
| Other values (36) | 2062743 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8113130 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 936712 | |
| 3 | 712585 | 8.8% |
| 9 | 620962 | 7.7% |
| 2 | 608096 | 7.5% |
| 5 | 560846 | 6.9% |
| 8 | 556014 | 6.9% |
| . | 545412 | 6.7% |
| 4 | 523946 | 6.5% |
| 7 | 502781 | 6.2% |
| 6 | 483033 | 6.0% |
| Other values (36) | 2062743 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8113130 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 936712 | |
| 3 | 712585 | 8.8% |
| 9 | 620962 | 7.7% |
| 2 | 608096 | 7.5% |
| 5 | 560846 | 6.9% |
| 8 | 556014 | 6.9% |
| . | 545412 | 6.7% |
| 4 | 523946 | 6.5% |
| 7 | 502781 | 6.2% |
| 6 | 483033 | 6.0% |
| Other values (36) | 2062743 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8113130 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 936712 | |
| 3 | 712585 | 8.8% |
| 9 | 620962 | 7.7% |
| 2 | 608096 | 7.5% |
| 5 | 560846 | 6.9% |
| 8 | 556014 | 6.9% |
| . | 545412 | 6.7% |
| 4 | 523946 | 6.5% |
| 7 | 502781 | 6.2% |
| 6 | 483033 | 6.0% |
| Other values (36) | 2062743 |
Interactions
Missing values
Sample
| Creation Date | Purchase Date | Fiscal Year | LPA Number | Purchase Order Number | Requisition Number | Acquisition Type | Sub-Acquisition Type | Acquisition Method | Sub-Acquisition Method | Department Name | Supplier Code | Supplier Name | Supplier Qualifications | Supplier Zip Code | CalCard | Item Name | Item Description | Quantity | Unit Price | Total Price | Classification Codes | Normalized UNSPSC | Commodity Title | Class | Class Title | Family | Family Title | Segment | Segment Title | Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 08/27/2013 | NaN | 2013-2014 | 7-12-70-26 | REQ0011118 | REQ0011118 | IT Goods | NaN | WSCA/Coop | NaN | Consumer Affairs, Department of | 1740272.0 | Pitney Bowes | NaN | NaN | NO | USB | USB | 1.0 | $1.00 | $1.00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 01/29/2014 | NaN | 2013-2014 | NaN | REQ0011932 | REQ0011932 | NON-IT Goods | NaN | Informal Competitive | NaN | Consumer Affairs, Department of | 1760085.0 | Rodea Auto Tech | NaN | NaN | NO | Tire Disposal | Tire Disposal | 2.0 | $2.00 | $4.00 | 76121504 | 76121504.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 11/01/2013 | NaN | 2013-2014 | NaN | REQ0011476 | REQ0011476 | IT Services | NaN | Informal Competitive | NaN | Consumer Affairs, Department of | 17224.0 | Smile Business Products, Inc | NaN | 95841 | NO | Labor | Labor | 4.5 | $150.00 | $675.00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 95841\n(38.662263, -121.346136) |
| 3 | 06/13/2014 | 06/05/2014 | 2013-2014 | NaN | 4500236642 | NaN | NON-IT Goods | NaN | Informal Competitive | NaN | Correctional Health Care Services | 1754462.0 | ASHAN INC | CA-MB CA-SB | 91436 | NO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 91436\n(34.151642, -118.49051) |
| 4 | 03/12/2014 | 03/12/2014 | 2013-2014 | 1-10-75-60A | 4500221028 | NaN | NON-IT Goods | NaN | Statewide Contract | NaN | Corrections and Rehabilitation, Department of | 1087660.0 | Technology Integration Group | NaN | 95814 | NO | Toner | Toner | 1.0 | $6080.26 | $6080.26 | 44103127 | 44103127.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 95814\n(38.580427, -121.494396) |
| 5 | 10/09/2014 | 10/01/2014 | 2014-2015 | NaN | 4500253427 | NaN | NON-IT Goods | NaN | Informal Competitive | NaN | Correctional Health Care Services | 1738777.0 | WALGREENS SPECIALTY PHARMACY LLC | NaN | 97008 | NO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 97008\n(45.460518, -122.806409) |
| 6 | 10/10/2014 | NaN | 2014-2015 | 1-14-75-60A | REQ0013911 | REQ0013911 | NON-IT Goods | NaN | Statewide Contract | NaN | Consumer Affairs, Department of | 1087660.0 | Technology Integration Group | NaN | 95814 | NO | HP 35A BLACK TONER | HP 35A BLACK TONER | 30.0 | $45.40 | $1362.00 | 44103127 | 44103127.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 95814\n(38.580427, -121.494396) |
| 7 | 04/24/2014 | 04/14/2014 | 2013-2014 | NaN | 12-64006.01 | NaN | NON-IT Services | Personal Services | Services are specifically exempt by statute | NaN | State Hospitals, Department of | 1069280.0 | David Gallardo | NaN | 93274 | NO | Radiation Oncology | Radiation Oncology | 1.0 | $400000.00 | $400000.00 | 85121615 | 85121615.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 93274\n(36.193481, -119.358379) |
| 8 | 02/06/2015 | NaN | 2014-2015 | 1-14-75-60A | REQ0014515 | REQ0014515 | NON-IT Goods | NaN | Statewide Contract | NaN | Consumer Affairs, Department of | 1087660.0 | Technology Integration Group | NaN | 95814 | NO | Black Toner Cartridge for CLJ 4700 | Black Toner Cartridge for CLJ 4700 | 16.0 | $127.06 | $2032.96 | 44103127 | 44103127.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 95814\n(38.580427, -121.494396) |
| 9 | 08/14/2013 | 07/26/2013 | 2013-2014 | NaN | 4500200308 | NaN | NON-IT Goods | NaN | Informal Competitive | NaN | Water Resources, Department of | 1014234.0 | CLARKE SALES | NaN | 91322 | NO | 1" ss 90* elbow , threaded | 1" ss 90* elbow , threaded | 4.0 | $21.65 | $86.60 | 401728 | 401728.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 91322\n(34.379263, -118.547301) |
| Creation Date | Purchase Date | Fiscal Year | LPA Number | Purchase Order Number | Requisition Number | Acquisition Type | Sub-Acquisition Type | Acquisition Method | Sub-Acquisition Method | Department Name | Supplier Code | Supplier Name | Supplier Qualifications | Supplier Zip Code | CalCard | Item Name | Item Description | Quantity | Unit Price | Total Price | Classification Codes | Normalized UNSPSC | Commodity Title | Class | Class Title | Family | Family Title | Segment | Segment Title | Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 346008 | 11/28/2012 | NaN | 2012-2013 | NaN | 1026 | NaN | NON-IT Goods | NaN | NCB | NaN | Highway Patrol, California | 1732038.0 | Commercial Vehicle Safety Alliance | NaN | 20770 | NO | Commercial Vehicle Safety Alliance (CVSA) Decals - Orange, 3rd Qtr. of 2013 | For delivery in 3rd qtr. of 2013 (Jul, Aug, Sep) | 135000.0 | $0.28 | $37800.00 | 55121607 | 55121607.0 | Decals | 55121600.0 | Labels | 55120000.0 | Signage and accessories | 55000000.0 | Published Products | 20770\n(39.000196, -76.882952) |
| 346009 | 05/10/2013 | 07/01/2013 | 2012-2013 | NaN | 3169558 | NaN | NON-IT Services | Legal Services | Services are specifically exempt by statute | NaN | General Services, Department of | 1135461.0 | Michael Diliberto | NaN | 90067 | NO | SE Pro Tem Services | Contractor will provide services as a Pro Tem ALJ during Special\nEducation hearings and mediations. | 1.0 | $25000.00 | $25000.00 | 93151507 | 93151507.0 | Administrative procedures or services | 93151500.0 | Public administration | 93150000.0 | Public administration and finance services | 93000000.0 | Politics and Civic Affairs Services | 90067\n(34.057398, -118.414336) |
| 346010 | 06/17/2014 | 06/05/2014 | 2013-2014 | NaN | P1475034 | NaN | NON-IT Services | Nonprofit Organizations | Informal Competitive | NaN | Fish and Wildlife, Department of | 1086212.0 | Marine Exchange of Southern California | NaN | 90733 | NO | Grant | Harbor Safety Committee Secretariat Services | 1.0 | $51268.60 | $51268.60 | 77131502 | 77131502.0 | Oil spillage control services | 77131500.0 | Oil pollution | 77130000.0 | Pollutants tracking and monitoring and rehabilitation services | 77000000.0 | Environmental Services | 90733\n(33.735802, -118.291397) |
| 346011 | 07/30/2013 | 07/30/2013 | 2013-2014 | 1-11-70-04O | 4500192139 | NaN | IT Services | NaN | Statewide Contract | NaN | Corrections and Rehabilitation, Department of | 17224.0 | Smile Business Products, Inc | NaN | 95841 | NO | Copier Maintenance | Copier Maintenance | 8.0 | $2600.00 | $20800.00 | 81112201 | 81112201.0 | Maintenance or support fees | 81112200.0 | Software maintenance and support | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95841\n(38.662263, -121.346136) |
| 346012 | 12/31/2013 | 12/31/2013 | 2013-2014 | NaN | P1300585 | NaN | NON-IT Goods | NaN | Fair and Reasonable | NaN | Franchise Tax Board | 59158.0 | Flash Business Solutions | CA-MB CA-SB | 95763-1046 | NO | forms | Report of Deposit forms | 1.0 | $2548.80 | $2548.80 | 14111806 | 14111806.0 | Business forms or questionnaires | 14111800.0 | Business use papers | 14110000.0 | Paper products | 14000000.0 | Paper Materials and Products | 95763-1046\n(38.681325, -121.163738) |
| 346013 | 11/03/2014 | 09/25/2014 | 2014-2015 | NaN | 4500252536 | NaN | NON-IT Goods | NaN | Informal Competitive | NaN | Corrections and Rehabilitation, Department of | 12205.0 | Superior Produce, Inc. | CA-SB | 95811 | NO | Inmate feeding: Oct. produce order, 2nd quar. | Inmate feeding: Oct. produce order, 2nd quar. | 1.0 | $37479.45 | $37479.45 | 93131608 | 93131608.0 | Food supply services | 93131600.0 | Food and nutrition policy planning and programs | 93130000.0 | Humanitarian aid and relief | 93000000.0 | Politics and Civic Affairs Services | 95811\n(38.581053, -121.488564) |
| 346014 | 08/14/2014 | 07/20/2011 | 2014-2015 | NaN | 10A1343 | NaN | NON-IT Services | Expert Witneses | Services are specifically exempt by statute | NaN | Transportation, Department of | 1018638.0 | CONFIDENTIAL - Information Withheld | NaN | 95816 | NO | Expert Witness | Expert Witness Real Estate Appraisals - Amendment for additional funds. | 1.0 | $35000.00 | $35000.00 | 80121903 | 80121903.0 | Expert witness service | 80121900.0 | Compensated legal participation services | 80120000.0 | Legal services | 80000000.0 | Management and Business Professionals and Administrative Services | 95816\n(38.57219, -121.467691) |
| 346015 | 05/09/2014 | NaN | 2013-2014 | NaN | 228 | NaN | IT Goods | NaN | SB/DVBE Option | NaN | High Speed Rail Authority, California | 1136849.0 | Straight-Line Solutions | CA-MB CA-SB | 95829 | NO | Inout Panel Cover | Projector accessories | 2.0 | $49.99 | $99.98 | 45111609\n56101710 | 45111609.0 | Multimedia projectors | 45111600.0 | Projectors and supplies | 45110000.0 | Audio and visual presentation and composing equipment | 45000000.0 | Printing and Photographic and Audio and Visual Equipment and Supplies | 95829\n(38.474725, -121.340819) |
| 346016 | 01/14/2014 | 01/14/2014 | 2013-2014 | NaN | P1300614 | NaN | NON-IT Goods | NaN | Fair and Reasonable | NaN | Franchise Tax Board | 8329.0 | Merritt Business Supplies | CA-MB CA-SB | 95630 | NO | Dremel 120 Volt Engraver | Dremel 120 Volt Engraver | 1.0 | $35.00 | $35.00 | 27112718 | 27112718.0 | Engravers | 27112700.0 | Power tools | 27110000.0 | Hand tools | 27000000.0 | Tools and General Machinery | 95630\n(38.670213, -121.147592) |
| 346017 | 10/09/2013 | 09/09/2013 | 2013-2014 | NaN | 2ui3L262 | NaN | NON-IT Services | Contracts with Local Governments | Emergency Purchase | NaN | Forestry and Fire Protection, Department of | 1050481.0 | Happy Valley Fire Protection District | NaN | 96007 | NO | LOCAL GOVERNMENT-LABOR | Local government engines on going fire "Clover" | 1.0 | $17455.91 | $17455.91 | 76122405 | 76122405.0 | Labor fee | 76122400.0 | Refuse disposal and treatment fees | 76120000.0 | Refuse disposal and treatment | 76000000.0 | Industrial Cleaning Services | 96007\n(40.456408, -122.315294) |
Duplicate rows
Most frequently occurring
| Creation Date | Purchase Date | Fiscal Year | LPA Number | Purchase Order Number | Requisition Number | Acquisition Type | Sub-Acquisition Type | Acquisition Method | Sub-Acquisition Method | Department Name | Supplier Code | Supplier Name | Supplier Qualifications | Supplier Zip Code | CalCard | Item Name | Item Description | Quantity | Unit Price | Total Price | Classification Codes | Normalized UNSPSC | Commodity Title | Class | Class Title | Family | Family Title | Segment | Segment Title | Location | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 409 | 04/21/2015 | 01/29/2015 | 2014-2015 | 5-06-58-20 | CF140541 | NaN | IT Services | NaN | Master Service Agreement | NaN | Forestry and Fire Protection, Department of | 1000530.0 | AT&T | NaN | 95134 | NO | UPS Network Management Card 2 | Network Maintenance | 1.0 | $512.55 | $512.55 | 81111804 | 81111804.0 | Wide area network WAN maintenance or support | 81111800.0 | System and system component administration services | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95134\n(37.410635, -121.940949) | 25 |
| 404 | 04/21/2015 | 01/29/2015 | 2014-2015 | 5-06-58-20 | CF140541 | NaN | IT Services | NaN | Master Service Agreement | NaN | Forestry and Fire Protection, Department of | 1000530.0 | AT&T | NaN | 95134 | NO | Trustwave X100 Appliance | Network Maintenance | 1.0 | $4500.00 | $4500.00 | 81111804 | 81111804.0 | Wide area network WAN maintenance or support | 81111800.0 | System and system component administration services | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95134\n(37.410635, -121.940949) | 24 |
| 326 | 04/08/2015 | 04/01/2015 | 2014-2015 | NaN | 4500221608 | NaN | NON-IT Goods | NaN | Informal Competitive | NaN | Water Resources, Department of | 35423.0 | Cal Best Industrial Supply | CA-MB CA-SB | 93308 | NO | PANTS,ARC/FLASH | PANTS,ARC/FLASH | 3.0 | $72.00 | $216.00 | 46181518 | 46181518.0 | Heat resistant clothing | 46181500.0 | Safety apparel | 46180000.0 | Personal safety and protection | 46000000.0 | Defense and Law Enforcement and Security and Safety Equipment and Supplies | 93308\n(35.485441, -119.013391) | 22 |
| 379 | 04/21/2015 | 01/29/2015 | 2014-2015 | 5-06-58-20 | CF140541 | NaN | IT Services | NaN | Master Service Agreement | NaN | Forestry and Fire Protection, Department of | 1000530.0 | AT&T | NaN | 95134 | NO | APC 2 Post Mounting Kit for Smart UPS and Symmetra | Network Maintenance | 2.0 | $181.05 | $362.10 | 81111804 | 81111804.0 | Wide area network WAN maintenance or support | 81111800.0 | System and system component administration services | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95134\n(37.410635, -121.940949) | 22 |
| 390 | 04/21/2015 | 01/29/2015 | 2014-2015 | 5-06-58-20 | CF140541 | NaN | IT Services | NaN | Master Service Agreement | NaN | Forestry and Fire Protection, Department of | 1000530.0 | AT&T | NaN | 95134 | NO | Cisco 3945 W/SPE 150 | Includes:\n Cisco AC Power Supply\n AC Power Cord\n Cisco Services Performance Engin 150 for Cisco\n IP Base License for Cisco\n Cisco Fan Assembly\n Cisco Config Pro Express on Router Flash\n 1GB DRAM\n 256 Compact Flash for Cisco\n Cisco IOS Un | 1.0 | $6500.00 | $6500.00 | 81111804 | 81111804.0 | Wide area network WAN maintenance or support | 81111800.0 | System and system component administration services | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95134\n(37.410635, -121.940949) | 22 |
| 387 | 04/21/2015 | 01/29/2015 | 2014-2015 | 5-06-58-20 | CF140541 | NaN | IT Services | NaN | Master Service Agreement | NaN | Forestry and Fire Protection, Department of | 1000530.0 | AT&T | NaN | 95134 | NO | APC Smart UPS X2000VA Rack Tower LCd | Network Maintenance | 1.0 | $1568.25 | $1568.25 | 81111804 | 81111804.0 | Wide area network WAN maintenance or support | 81111800.0 | System and system component administration services | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95134\n(37.410635, -121.940949) | 20 |
| 396 | 04/21/2015 | 01/29/2015 | 2014-2015 | 5-06-58-20 | CF140541 | NaN | IT Services | NaN | Master Service Agreement | NaN | Forestry and Fire Protection, Department of | 1000530.0 | AT&T | NaN | 95134 | NO | Cradlepoint ARC CBA750B Wireless Router | Network Maintenance | 1.0 | $599.00 | $599.00 | 81111804 | 81111804.0 | Wide area network WAN maintenance or support | 81111800.0 | System and system component administration services | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95134\n(37.410635, -121.940949) | 17 |
| 400 | 04/21/2015 | 01/29/2015 | 2014-2015 | 5-06-58-20 | CF140541 | NaN | IT Services | NaN | Master Service Agreement | NaN | Forestry and Fire Protection, Department of | 1000530.0 | AT&T | NaN | 95134 | NO | One Port T3 Network Module | Network Maintenance | 1.0 | $4675.00 | $4675.00 | 81111804 | 81111804.0 | Wide area network WAN maintenance or support | 81111800.0 | System and system component administration services | 81110000.0 | Computer services | 81000000.0 | Engineering and Research and Technology Based Services | 95134\n(37.410635, -121.940949) | 17 |
| 63 | 01/10/2014 | 01/08/2014 | 2013-2014 | NaN | 4500206131 | NaN | NON-IT Services | Agreements with other governmental entities and public universities | Services are specifically exempt by policy | NaN | Water Resources, Department of | 1117701.0 | South Coast Air Quality Management District | NaN | 91765 | NO | AV AQMD Fee | AV AQMD Fee | 1.0 | $224.29 | $224.29 | 93151516 | 93151516.0 | Building permit | 93151500.0 | Public administration | 93150000.0 | Public administration and finance services | 93000000.0 | Politics and Civic Affairs Services | 91765\n(33.997935, -117.817436) | 16 |
| 106 | 01/28/2015 | 01/27/2015 | 2014-2015 | NaN | 4500219416 | NaN | NON-IT Goods | NaN | Informal Competitive | NaN | Water Resources, Department of | 6523.0 | IBHP INCORPORATED | CA-SB | 98733 | NO | PANTS,ARC/FLASH | PANTS,ARC/FLASH | 2.0 | $51.50 | $103.00 | 46181518 | 46181518.0 | Heat resistant clothing | 46181500.0 | Safety apparel | 46180000.0 | Personal safety and protection | 46000000.0 | Defense and Law Enforcement and Security and Safety Equipment and Supplies | 98733\n | 14 |